using System;
using System.Configuration;
using System.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
using System.Collections;

namespace MySql
{
    public abstract class MySQLHelper 
    {
        public static DataRow ExecuteDataRow(string connectionString, string commandText, params MySqlParameter[] parms)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteDataRow(connectionString, commandText, parms);
        }
        public static DataSet ExecuteDataset(MySqlConnection connection, string commandText)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(connection, commandText);
        }
        public static DataSet ExecuteDataset(string connectionString, string commandText)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(connectionString, commandText);
        }
        public static DataSet ExecuteDataset(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(connection, commandText, commandParameters);
        }
        public static DataSet ExecuteDataset(string connectionString, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(connectionString, commandText, commandParameters);
        }
        public static int ExecuteNonQuery(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(connection, commandText, commandParameters);
        }
        public static int ExecuteNonQuery(string connectionString, string commandText, params MySqlParameter[] parms)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(connectionString, commandText, parms);
        }
        public static MySqlDataReader ExecuteReader(string connectionString, string commandText)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(connectionString, commandText);
        }
        public static MySqlDataReader ExecuteReader(string connectionString, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(connectionString, commandText, commandParameters);
        }
        public static object ExecuteScalar(MySqlConnection connection, string commandText)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(connection, commandText);
        }
        public static object ExecuteScalar(string connectionString, string commandText)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(connectionString, commandText);
        }
        public static object ExecuteScalar(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(connection, commandText, commandParameters);
        }
        public static object ExecuteScalar(string connectionString, string commandText, params MySqlParameter[] commandParameters)
        {
            return MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(connectionString, commandText, commandParameters);
        }
        public static void UpdateDataSet(string connectionString, string commandText, DataSet ds, string tablename)
        {
            MySql.Data.MySqlClient.MySqlHelper.UpdateDataSet(connectionString, commandText, ds, tablename);
        }
    }
}
